Hi,
I was trying to use the enhanced Excel export tool and it worked fine for me until i updated excel to 2013. Now i get merged data on top of each other and the export is out of sync. Is there any solution for this.Did any of you face the same issue? Note:I found this script in Galactic solution website. Gsquare - Wed Sep 21 04:42:30 EDT 2016 |
Re: Enhanced Excel export error Had similar problems when we moved to Office 2013. The handling of OLE objects seems to be changed, I solved the export problems by not exporting OLE. Also the freeze rows / split display options sometimes ran into problems. Try to edit the options in Enchanced Excel Export dialog. |
Re: Enhanced Excel export error What Pekka said is good advice. You might also try creating an Excel template first (xltx), then on the "Template" tab of the Enhanced Export, select "Existing template" and export to the one you created. That might help you avoid the problems. |
Re: Enhanced Excel export error Thanks for the inputs. I shall try both the solutions and get back. |
Re: Enhanced Excel export error PekkaMakinen - Fri Sep 23 02:23:51 EDT 2016 Had similar problems when we moved to Office 2013. The handling of OLE objects seems to be changed, I solved the export problems by not exporting OLE. Also the freeze rows / split display options sometimes ran into problems. Try to edit the options in Enchanced Excel Export dialog. Setting the split header toggle to false, did the trick!!! Thanks for the help. |